Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	2966
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	301.4 KiB
Average record size in memory	104.0 B

Variable types

Numeric	13

Alerts

`gross_revenue` is highly correlated with `qt_invoices` and 3 other fields	High correlation
`recency_days` is highly correlated with `qt_invoices`	High correlation
`qt_invoices` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`no_items` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`assortment` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly correlated with `avg_assortment`	High correlation
`avg_recency_days` is highly correlated with `frequency`	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`avg_assortment` is highly correlated with `assortment` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `qt_invoices` and 1 other fields	High correlation
`qt_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`no_items` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`assortment` is highly correlated with `qt_invoices`	High correlation
`avg_ticket` is highly correlated with `qt_returned` and 1 other fields	High correlation
`qt_returned` is highly correlated with `avg_ticket` and 1 other fields	High correlation
`avg_basket_size` is highly correlated with `avg_ticket` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `qt_invoices` and 2 other fields	High correlation
`qt_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`no_items` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`assortment` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_recency_days` is highly correlated with `frequency`	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly correlated with `no_items`	High correlation
`avg_assortment` is highly correlated with `assortment`	High correlation
`gross_revenue` is highly correlated with `qt_invoices` and 5 other fields	High correlation
`qt_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`no_items` is highly correlated with `gross_revenue` and 5 other fields	High correlation
`assortment` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qt_returned` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_assortment` is highly correlated with `assortment`	High correlation
`avg_ticket` is highly skewed (γ1 = 53.41722488)	Skewed
`qt_returned` is highly skewed (γ1 = 52.67648474)	Skewed
`avg_basket_size` is highly skewed (γ1 = 44.64531467)	Skewed
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`recency_days` has 34 (1.1%) zeros	Zeros
`qt_returned` has 1480 (49.9%) zeros	Zeros

Reproduction

Analysis started	2021-11-16 12:10:01.361578
Analysis finished	2021-11-16 12:10:34.340894
Duration	32.98 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	2966
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2309.167229

Minimum	0
Maximum	5690
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	185.25
Q1	926.25
median	2113.5
Q3	3523.75
95-th percentile	5011
Maximum	5690
Range	5690
Interquartile range (IQR)	2597.5

Descriptive statistics

Standard deviation	1547.505435
Coefficient of variation (CV)	0.6701573693
Kurtosis	-1.011941625
Mean	2309.167229
Median Absolute Deviation (MAD)	1265.5
Skewness	0.3397296495
Sum	6848990
Variance	2394773.072
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
3002	1	< 0.1%
2987	1	< 0.1%
2990	1	< 0.1%
2991	1	< 0.1%
2992	1	< 0.1%
2993	1	< 0.1%
2996	1	< 0.1%
2998	1	< 0.1%
2999	1	< 0.1%
Other values (2956)	2956	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5690	1	< 0.1%
5671	1	< 0.1%
5661	1	< 0.1%
5655	1	< 0.1%
5634	1	< 0.1%
5630	1	< 0.1%
5624	1	< 0.1%
5613	1	< 0.1%
5612	1	< 0.1%
5602	1	< 0.1%

customer_id
Real number (ℝ_≥0)

UNIQUE

Distinct	2966
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15270.64633

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	12347
5-th percentile	12619.25
Q1	13799.75
median	15220.5
Q3	16769.5
95-th percentile	17964.75
Maximum	18287
Range	5940
Interquartile range (IQR)	2969.75

Descriptive statistics

Standard deviation	1719.368253
Coefficient of variation (CV)	0.1125930243
Kurtosis	-1.206285243
Mean	15270.64633
Median Absolute Deviation (MAD)	1487
Skewness	0.03191154775
Sum	45292737
Variance	2956227.19
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
17588	1	< 0.1%
14905	1	< 0.1%
16103	1	< 0.1%
14626	1	< 0.1%
14868	1	< 0.1%
18246	1	< 0.1%
17115	1	< 0.1%
16611	1	< 0.1%
15912	1	< 0.1%
Other values (2956)	2956	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18269	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2951
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2749.505877

Minimum	6.2
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	6.2
5-th percentile	230.9525
Q1	571.02
median	1085.51
Q3	2310.295
95-th percentile	7226.025
Maximum	279138.02
Range	279131.82
Interquartile range (IQR)	1739.275

Descriptive statistics

Standard deviation	10565.25243
Coefficient of variation (CV)	3.842600417
Kurtosis	355.1539792
Mean	2749.505877
Median Absolute Deviation (MAD)	671.39
Skewness	16.7946648
Sum	8155034.43
Variance	111624558.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2053.02	2	0.1%
331	2	0.1%
734.94	2	0.1%
1025.44	2	0.1%
598.2	2	0.1%
533.33	2	0.1%
731.9	2	0.1%
2092.32	2	0.1%
379.65	2	0.1%
745.06	2	0.1%
Other values (2941)	2946	99.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6.2	1	< 0.1%
13.3	1	< 0.1%
36.56	1	< 0.1%
45	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%
70.02	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
136275.72	1	< 0.1%
124564.53	1	< 0.1%
116729.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%

recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	272
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.19285233

Minimum	0
Maximum	373
Zeros	34
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	11
median	31
Q3	81
95-th percentile	242
Maximum	373
Range	373
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	77.57466444
Coefficient of variation (CV)	1.20846265
Kurtosis	2.761679903
Mean	64.19285233
Median Absolute Deviation (MAD)	26
Skewness	1.795006445
Sum	190396
Variance	6017.828563
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.3%
4	87	2.9%
3	85	2.9%
2	84	2.8%
8	76	2.6%
10	67	2.3%
7	66	2.2%
9	66	2.2%
17	64	2.2%
16	55	1.9%
Other values (262)	2217	74.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	34	1.1%
1	99	3.3%
2	84	2.8%
3	85	2.9%
4	87	2.9%
5	43	1.4%
7	66	2.2%
8	76	2.6%
9	66	2.2%
10	67	2.3%

Value	Count	Frequency (%)
373	2	0.1%
372	3	0.1%
371	1	< 0.1%
368	1	< 0.1%
366	4	0.1%
365	2	0.1%
364	1	< 0.1%
360	1	< 0.1%
359	1	< 0.1%
358	4	0.1%

qt_invoices
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	57
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.723196224

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.845798044
Coefficient of variation (CV)	1.545604536
Kurtosis	190.2265924
Mean	5.723196224
Median Absolute Deviation (MAD)	2
Skewness	10.74717886
Sum	16975
Variance	78.24814304
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	785	26.5%
3	497	16.8%
4	394	13.3%
5	236	8.0%
1	189	6.4%
6	173	5.8%
7	139	4.7%
8	98	3.3%
9	69	2.3%
10	54	1.8%
Other values (47)	332	11.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	189	6.4%
2	785	26.5%
3	497	16.8%
4	394	13.3%
5	236	8.0%
6	173	5.8%
7	139	4.7%
8	98	3.3%
9	69	2.3%
10	54	1.8%

Value	Count	Frequency (%)
206	1	< 0.1%
198	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	1	< 0.1%
90	1	< 0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%

no_items
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1677
Distinct (%)	56.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1610.217465

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	2
5-th percentile	103
Q1	297
median	642
Q3	1401
95-th percentile	4408
Maximum	196844
Range	196842
Interquartile range (IQR)	1104

Descriptive statistics

Standard deviation	5889.962303
Coefficient of variation (CV)	3.657867606
Kurtosis	465.6488492
Mean	1610.217465
Median Absolute Deviation (MAD)	422.5
Skewness	17.85151444
Sum	4775905
Variance	34691655.93
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
88	9	0.3%
150	9	0.3%
288	8	0.3%
272	8	0.3%
260	8	0.3%
246	8	0.3%
134	8	0.3%
84	8	0.3%
219	7	0.2%
Other values (1667)	2882	97.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	2	0.1%
12	2	0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
25	1	< 0.1%
26	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
80179	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57872	1	< 0.1%

assortment
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	467
Distinct (%)	15.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.7697235

Minimum	1
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	29
median	67
Q3	135
95-th percentile	382
Maximum	7838
Range	7837
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	269.4103935
Coefficient of variation (CV)	2.194436753
Kurtosis	354.1904831
Mean	122.7697235
Median Absolute Deviation (MAD)	44
Skewness	15.67478035
Sum	364135
Variance	72581.96011
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	44	1.5%
20	37	1.2%
35	35	1.2%
29	34	1.1%
15	33	1.1%
19	33	1.1%
11	32	1.1%
25	31	1.0%
26	30	1.0%
27	30	1.0%
Other values (457)	2627	88.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5	0.2%
2	14	0.5%
3	16	0.5%
4	17	0.6%
5	26	0.9%
6	28	0.9%
7	18	0.6%
8	19	0.6%
9	26	0.9%
10	28	0.9%

Value	Count	Frequency (%)
7838	1	< 0.1%
5589	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2697	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1672	1	< 0.1%
1637	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1993
Distinct (%)	67.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51.92923803

Minimum	2.15
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	2.15
5-th percentile	4.915
Q1	13.12
median	17.94
Q3	24.9875
95-th percentile	90.5025
Maximum	56157.5
Range	56155.35
Interquartile range (IQR)	11.8675

Descriptive statistics

Standard deviation	1037.458389
Coefficient of variation (CV)	19.9783095
Kurtosis	2887.786898
Mean	51.92923803
Median Absolute Deviation (MAD)	5.97
Skewness	53.41722488
Sum	154022.12
Variance	1076319.91
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.49	7	0.2%
16.82	6	0.2%
16.39	6	0.2%
16.92	6	0.2%
19.06	6	0.2%
17.66	6	0.2%
17.71	6	0.2%
19.44	5	0.2%
10	5	0.2%
17.13	5	0.2%
Other values (1983)	2908	98.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.15	1	< 0.1%
2.43	1	< 0.1%
2.46	1	< 0.1%
2.51	1	< 0.1%
2.52	1	< 0.1%
2.65	1	< 0.1%
2.66	1	< 0.1%
2.71	1	< 0.1%
2.76	1	< 0.1%
2.77	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
4453.43	1	< 0.1%
3202.92	1	< 0.1%
1687.2	1	< 0.1%
952.99	1	< 0.1%
872.13	1	< 0.1%
841.02	1	< 0.1%
651.17	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%

avg_recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	1258
Distinct (%)	42.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.37893552

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	26
median	48.39285714
Q3	85.33333333
95-th percentile	201
Maximum	366
Range	365
Interquartile range (IQR)	59.33333333

Descriptive statistics

Standard deviation	63.56115532
Coefficient of variation (CV)	0.9433386685
Kurtosis	4.882651397
Mean	67.37893552
Median Absolute Deviation (MAD)	26.27380952
Skewness	2.062289986
Sum	199845.9227
Variance	4040.020465
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	25	0.8%
70	21	0.7%
4	21	0.7%
7	20	0.7%
35	18	0.6%
49	18	0.6%
46	17	0.6%
21	17	0.6%
11	17	0.6%
28	16	0.5%
Other values (1248)	2776	93.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	16	0.5%
1.5	1	< 0.1%
2	13	0.4%
2.5	1	< 0.1%
2.601398601	1	< 0.1%
3	15	0.5%
3.321428571	1	< 0.1%
3.330357143	1	< 0.1%
3.5	2	0.1%
4	21	0.7%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	1348
Distinct (%)	45.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.06316555961

Minimum	0.005449591281
Maximum	3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0.005449591281
5-th percentile	0.009433962264
Q1	0.01777777778
median	0.02929636612
Q3	0.05531929419
95-th percentile	0.2222222222
Maximum	3
Range	2.994550409
Interquartile range (IQR)	0.03754151641

Descriptive statistics

Standard deviation	0.1344005805
Coefficient of variation (CV)	2.127750967
Kurtosis	122.000165
Mean	0.06316555961
Median Absolute Deviation (MAD)	0.01427006162
Skewness	8.794847332
Sum	187.3490498
Variance	0.01806351605
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.3333333333	21	0.7%
0.1666666667	21	0.7%
0.02777777778	20	0.7%
0.09090909091	19	0.6%
0.0625	17	0.6%
0.1333333333	16	0.5%
0.4	15	0.5%
0.03571428571	15	0.5%
0.25	15	0.5%
0.02380952381	15	0.5%
Other values (1338)	2792	94.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005494505495	1	< 0.1%
0.005509641873	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
3	1	< 0.1%
2	1	< 0.1%
1.571428571	1	< 0.1%
1.5	3	0.1%
1	14	0.5%
0.8333333333	1	< 0.1%
0.75	1	< 0.1%
0.6666666667	12	0.4%
0.6487935657	1	< 0.1%
0.6	1	< 0.1%

qt_returned
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	173
Distinct (%)	5.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.25556305

Minimum	0
Maximum	80995
Zeros	1480
Zeros (%)	49.9%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	6
95-th percentile	62.75
Maximum	80995
Range	80995
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	1504.24228
Coefficient of variation (CV)	28.78626106
Kurtosis	2830.792868
Mean	52.25556305
Median Absolute Deviation (MAD)	1
Skewness	52.67648474
Sum	154990
Variance	2262744.836
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1480	49.9%
1	295	9.9%
3	169	5.7%
6	93	3.1%
2	86	2.9%
4	71	2.4%
5	43	1.4%
12	43	1.4%
8	40	1.3%
7	38	1.3%
Other values (163)	608	20.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1480	49.9%
1	295	9.9%
2	86	2.9%
3	169	5.7%
4	71	2.4%
5	43	1.4%
6	93	3.1%
7	38	1.3%
8	40	1.3%
9	36	1.2%

Value	Count	Frequency (%)
80995	1	< 0.1%
9014	1	< 0.1%
4824	1	< 0.1%
4027	1	< 0.1%
2302	2	0.1%
1776	1	< 0.1%
1608	1	< 0.1%
1589	1	< 0.1%
1515	1	< 0.1%
1278	1	< 0.1%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1980
Distinct (%)	66.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	250.0850739

Minimum	1
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	44.29166667
Q1	103.3083333
median	172.3809524
Q3	281.9230769
95-th percentile	600
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	178.6147436

Descriptive statistics

Standard deviation	791.9796007
Coefficient of variation (CV)	3.166840741
Kurtosis	2252.924831
Mean	250.0850739
Median Absolute Deviation (MAD)	83
Skewness	44.64531467
Sum	741752.3291
Variance	627231.6879
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	10	0.3%
82	9	0.3%
73	9	0.3%
86	9	0.3%
140	8	0.3%
60	8	0.3%
136	8	0.3%
75	8	0.3%
88	8	0.3%
Other values (1970)	2878	97.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2801	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%

avg_assortment
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1006
Distinct (%)	33.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.17083728

Minimum	1
Maximum	299.7058824
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	3.480263158
Q1	10
median	17.2
Q3	27.75
95-th percentile	57
Maximum	299.7058824
Range	298.7058824
Interquartile range (IQR)	17.75

Descriptive statistics

Standard deviation	19.52296715
Coefficient of variation (CV)	0.8805696829
Kurtosis	27.65907366
Mean	22.17083728
Median Absolute Deviation (MAD)	8.2
Skewness	3.497535954
Sum	65758.70338
Variance	381.1462465
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	54	1.8%
14	39	1.3%
11	38	1.3%
9	33	1.1%
18	32	1.1%
17	31	1.0%
1	31	1.0%
20	31	1.0%
10	30	1.0%
16	29	1.0%
Other values (996)	2618	88.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	31	1.0%
1.2	1	< 0.1%
1.25	1	< 0.1%
1.333333333	2	0.1%
1.5	8	0.3%
1.568181818	1	< 0.1%
1.571428571	1	< 0.1%
1.666666667	4	0.1%
1.833333333	1	< 0.1%
2	24	0.8%

Value	Count	Frequency (%)
299.7058824	1	< 0.1%
259	1	< 0.1%
203.5	1	< 0.1%
148	1	< 0.1%
145	1	< 0.1%
136.125	1	< 0.1%
135.5	1	< 0.1%
127	1	< 0.1%
122	1	< 0.1%
118	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	qt_invoices	no_items	assortment	avg_ticket	avg_recency_days	frequency	qt_returned	avg_basket_size	avg_assortment
0	0	17850	5391.21	372.0	34.0	1733.0	297.0	18.15	35.500000	0.486111	21.0	50.970588	8.735294
1	1	13047	3232.59	56.0	9.0	1390.0	171.0	18.90	27.250000	0.048780	6.0	154.444444	19.000000
2	2	12583	6705.38	2.0	15.0	5028.0	232.0	28.90	23.187500	0.045699	50.0	335.200000	15.466667
3	3	13748	948.25	95.0	5.0	439.0	28.0	33.87	92.666667	0.017921	0.0	87.800000	5.600000
4	4	15100	876.00	333.0	3.0	80.0	3.0	292.00	8.600000	0.136364	22.0	26.666667	1.000000
5	5	15291	4623.30	25.0	14.0	2102.0	102.0	45.33	23.200000	0.054441	27.0	150.142857	7.285714
6	6	14688	5630.87	7.0	21.0	3621.0	327.0	17.22	18.300000	0.073569	281.0	172.428571	15.571429
7	7	17809	5411.91	16.0	12.0	2057.0	61.0	88.72	35.700000	0.039106	41.0	171.416667	5.083333
8	8	15311	60767.90	0.0	91.0	38194.0	2379.0	25.54	4.144444	0.315508	231.0	419.714286	26.142857
9	9	16098	2005.63	87.0	7.0	613.0	67.0	29.93	47.666667	0.024390	0.0	87.571429	9.571429

Last rows

	df_index	customer_id	gross_revenue	recency_days	qt_invoices	no_items	assortment	avg_ticket	avg_recency_days	frequency	qt_returned	avg_basket_size	avg_assortment
2956	5602	17727	1060.25	15.0	1.0	645.0	66.0	16.06	6.0	0.285714	6.0	645.000000	66.0
2957	5612	17232	421.52	2.0	2.0	203.0	36.0	11.71	12.0	0.153846	0.0	101.500000	18.0
2958	5613	17468	137.00	10.0	2.0	116.0	5.0	27.40	4.0	0.400000	0.0	58.000000	2.5
2959	5624	13596	697.04	5.0	2.0	406.0	166.0	4.20	7.0	0.250000	0.0	203.000000	83.0
2960	5630	14893	1237.85	9.0	2.0	799.0	73.0	16.96	2.0	0.666667	0.0	399.500000	36.5
2961	5634	12479	473.20	11.0	1.0	382.0	30.0	15.77	4.0	0.333333	34.0	382.000000	30.0
2962	5655	14126	706.13	7.0	3.0	508.0	15.0	47.08	3.0	1.000000	50.0	169.333333	5.0
2963	5661	13521	1092.39	1.0	3.0	733.0	435.0	2.51	4.5	0.300000	0.0	244.333333	145.0
2964	5671	15060	301.84	8.0	4.0	262.0	120.0	2.52	1.0	2.000000	0.0	65.500000	30.0
2965	5690	12558	269.96	7.0	1.0	196.0	11.0	24.54	6.0	0.285714	102.0	196.000000	11.0

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows